package com.group.EducationalSystem.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import com.group.EducationalSystem.bean.Root;
import com.group.EducationalSystem.bean.Score;
import com.group.EducationalSystem.bean.Student;
import com.group.EducationalSystem.bean.Teacher;
import com.group.EducationalSystem.bean.User;

@Mapper
public interface RootMapper {
	Root getRoot(@Param("root_number") String root_number);
	void prefectRoot(Root root);
	void changeRoot(@Param("change_phone")String change_phone,@Param("change_box")String change_box,@Param("change_home")String changehome,@Param("number")String number);
	List<Student> getStudent_information();
	Student getStudentByAccount(@Param("account") String account);
	List<Student> getStudentByName(@Param("name") String name);
	List<Student> getStudentByNameOrAccount(@Param("account") String account,@Param("name") String name);
	void delstudent(@Param("student_id")String student_id);
	List<Teacher> getTeacherInformation();
	void delteacher(@Param("teacher_id") String teacher_id);
	List<Teacher> getTeacherByAccount(@Param("account") String account);
	List<Teacher> getTeacherByName(@Param("name") String name);
	List<Teacher> getTeacherByNameOrAccount(@Param("account") String account,@Param("name") String name);
	Student selectStudent (@Param("student_id")String student_id);
	void deluser(@Param("account")String account);
	void del_student_score(@Param("student_id")String student_id);
	List<Score> getScore_tab();
	List<Score> getScore_tabBystudent_name(@Param("student_name") String student_name);
	List<Score> getScore_tabBycourse_name(@Param("course_name") String course_name);
	List<Score> getScore_tabByName(@Param("student_name") String student_name,@Param("course_name") String course_name);
	List<User> getUser();
	void delUser(@Param("user_id")String user_id);
	User getUserbyId(@Param("user_id")String user_id);
	void delStudentByaccount(@Param("student_number")String student_number);
	void delteacherByAccount(@Param("teacher_number")String teacher_number);
	void addUser(@Param("password")String password,@Param("account")String account,@Param("power")String power,@Param("image")String image);
}
